package com.gxa.dao;

import com.gxa.pojo.Department;
import com.gxa.pojo.Role;
import com.gxa.pojo.User;

import java.sql.SQLException;
import java.util.List;

public interface EmpDao {
    List<User> queryemplist(Integer p1,Integer p2) throws SQLException;

    List<User> queryUserList(Integer p1, Integer p2,String username) throws SQLException;
    Department getDepartment(Integer department_id) throws SQLException;
    Role getRole(Integer role_id) throws SQLException;
    Integer countUser() throws SQLException;
    Integer countUser(String username) throws SQLException;
    Integer addEmp(User user) throws SQLException;
    Role searchRole(User user) throws SQLException;
    Integer delUser(String id) throws SQLException;
    Integer updateUser(User user) throws SQLException;
    Integer enableUser(String id) throws SQLException;
    Integer disableUser(String id) throws SQLException;
    User statusUser(String id) throws SQLException;
    Department searchDepartName(Integer id) throws SQLException;
    Integer editUserInfo(String username,String name_num,String oldpassword,String newpassword) throws SQLException;
}
